package com.itheima.dao;

import org.apache.ibatis.annotations.Select;

/**
 * @author hhj
 */
public interface MemberDao {

    @Select("select count(id) from t_member where regTime<=#{value}")
    Integer findMemberByDate(String date);

    @Select("select count(id) from t_member where regTime=#{value}")
    Integer findMemberCountByDay(String today);

    //总会员
    @Select("select count(id) from t_member")
    Integer findMemberCount();

    @Select("select count(id) from t_member where regTime>=#{value}")
    Integer findMemberCountByWeek(String thisWeekFirstDay);

    @Select("select count(id) from t_member where regTime>=#{value}")
    Integer findMemberCountByMonth(String thisMonthFirstDay);
}
